Home Tech info Quiz technology

[QUIZ] Check your understanding of SQL - Part 2

Continue series What do you know about SQL? , part 2 continues with questions that revolve around basic knowledge in databases.

  1. Question 1: In SQL, how to insert a new record into the "Persons" table?
    1. INSERT INTO Persons VALUES ('Jimmy', 'Jackson')
    2. INSERT VALUES ('Jimmy', 'Jackson') INTO Persons
    3. INSERT ('Jimmy', 'Jackson') INTO Persons
  2. Question 2: In SQL, how to insert the record "LastName" worth "Olsen" in the "Persons" table?
    1. INSERT ('Olsen') INTO Persons (LastName)
    2. INSERT INTO Persons ('Olsen') INTO LastName
    3. INSERT INTO Persons (LastName) VALUES ('Olsen')
  3. Question 3: How to change "Hansen" to "Nilsen" in the "LastName" column in the "Persons" table?
    1. MODIFY Persons SET LastName = 'Nilsen' WHERE LastName = 'Hansen'
    2. UPDATE Persons SET LastName = 'Nilsen' WHERE LastName = 'Hansen'
    3. MODIFY Persons SET LastName = 'Hansen' INTO LastName = 'Nilsen
    4. UPDATE Persons SET LastName = 'Hansen' INTO LastName = 'Nilsen'
  4. Question 4: In SQL, how to delete the "Peter" record from the "FirstName" column in the "Persons" table?
    1. DELETE FirstName = 'Peter' FROM Persons
    2. DELETE ROW FirstName = 'Peter' FROM Persons
    3. DELETE FROM Persons WHERE FirstName = 'Peter'
  5. Question 5: In SQL, how to return the number of records in the "Persons" table?
    1. SELECT COLUMNS (*) FROM Persons
    2. SELECT COUNT (*) FROM Persons
    3. SELECT LEN (*) FROM Persons
    4. SELECT NO (*) FROM Persons
  6. Question 6: Where is the most popular type of JOIN?
    1. INNER JOIN
    2. INSIDE JOIN
    3. JOINED TABLE
    4. JOINED
  7. Question 7: Which operator is used to retrieve data in a range?
    1. RANGE
    2. BETWEEN
    3. WITHIN
  8. Question 8: The NOT NULL constraint does not accept a null value column.
    1. It's correct
    2. False
  9. Question 9: Which clauses are used to find values ​​according to certain patterns?
    1. LIKE
    2. GET
    3. FROM
  10. Question 10: Which SQL statement is used to create the table in the database?
    1. CREATE DB
    2. CREATE TABLE
    3. CREATE DATABASE TAB
    4. CREATE DATABASE TABLE
learn sql sql quizzes database test quiz sql check sql sql knowledge sql test sql exercises
4.4 ★ | 5 Vote
« PREV : [QUIZ] Test your...
[QUIZ] Test your... : NEXT »
Read More
Maybe you are interested